package com.wn.purchaeReturn.entity;

import java.math.BigDecimal;
import java.util.ArrayList;
import java.util.Date;
import java.util.Iterator;
import java.util.List;

public class PurPurchasebillExample {
    protected String orderByClause;

    protected boolean distinct;

    protected List<Criteria> oredCriteria;

    private Integer limit;

    private Long offset;

    public PurPurchasebillExample() {
        oredCriteria = new ArrayList<Criteria>();
    }

    public void setOrderByClause(String orderByClause) {
        this.orderByClause = orderByClause;
    }

    public String getOrderByClause() {
        return orderByClause;
    }

    public void setDistinct(boolean distinct) {
        this.distinct = distinct;
    }

    public boolean isDistinct() {
        return distinct;
    }

    public List<Criteria> getOredCriteria() {
        return oredCriteria;
    }

    public void or(Criteria criteria) {
        oredCriteria.add(criteria);
    }

    public Criteria or() {
        Criteria criteria = createCriteriaInternal();
        oredCriteria.add(criteria);
        return criteria;
    }

    public Criteria createCriteria() {
        Criteria criteria = createCriteriaInternal();
        if (oredCriteria.size() == 0) {
            oredCriteria.add(criteria);
        }
        return criteria;
    }

    protected Criteria createCriteriaInternal() {
        Criteria criteria = new Criteria();
        return criteria;
    }

    public void clear() {
        oredCriteria.clear();
        orderByClause = null;
        distinct = false;
    }

    public void setLimit(Integer limit) {
        this.limit = limit;
    }

    public Integer getLimit() {
        return limit;
    }

    public void setOffset(Long offset) {
        this.offset = offset;
    }

    public Long getOffset() {
        return offset;
    }

    protected abstract static class GeneratedCriteria {
        protected List<Criterion> criteria;

        protected GeneratedCriteria() {
            super();
            criteria = new ArrayList<Criterion>();
        }

        public boolean isValid() {
            return criteria.size() > 0;
        }

        public List<Criterion> getAllCriteria() {
            return criteria;
        }

        public List<Criterion> getCriteria() {
            return criteria;
        }

        protected void addCriterion(String condition) {
            if (condition == null) {
                throw new RuntimeException("Value for condition cannot be null");
            }
            criteria.add(new Criterion(condition));
        }

        protected void addCriterion(String condition, Object value, String property) {
            if (value == null) {
                throw new RuntimeException("Value for " + property + " cannot be null");
            }
            criteria.add(new Criterion(condition, value));
        }

        protected void addCriterion(String condition, Object value1, Object value2, String property) {
            if (value1 == null || value2 == null) {
                throw new RuntimeException("Between values for " + property + " cannot be null");
            }
            criteria.add(new Criterion(condition, value1, value2));
        }

        protected void addCriterionForJDBCDate(String condition, Date value, String property) {
            if (value == null) {
                throw new RuntimeException("Value for " + property + " cannot be null");
            }
            addCriterion(condition, new java.sql.Date(value.getTime()), property);
        }

        protected void addCriterionForJDBCDate(String condition, List<Date> values, String property) {
            if (values == null || values.size() == 0) {
                throw new RuntimeException("Value list for " + property + " cannot be null or empty");
            }
            List<java.sql.Date> dateList = new ArrayList<java.sql.Date>();
            Iterator<Date> iter = values.iterator();
            while (iter.hasNext()) {
                dateList.add(new java.sql.Date(iter.next().getTime()));
            }
            addCriterion(condition, dateList, property);
        }

        protected void addCriterionForJDBCDate(String condition, Date value1, Date value2, String property) {
            if (value1 == null || value2 == null) {
                throw new RuntimeException("Between values for " + property + " cannot be null");
            }
            addCriterion(condition, new java.sql.Date(value1.getTime()), new java.sql.Date(value2.getTime()), property);
        }

        public Criteria andPurchasenoIsNull() {
            addCriterion("PURCHASENO is null");
            return (Criteria) this;
        }

        public Criteria andPurchasenoIsNotNull() {
            addCriterion("PURCHASENO is not null");
            return (Criteria) this;
        }

        public Criteria andPurchasenoEqualTo(String value) {
            addCriterion("PURCHASENO =", value, "purchaseno");
            return (Criteria) this;
        }

        public Criteria andPurchasenoNotEqualTo(String value) {
            addCriterion("PURCHASENO <>", value, "purchaseno");
            return (Criteria) this;
        }

        public Criteria andPurchasenoGreaterThan(String value) {
            addCriterion("PURCHASENO >", value, "purchaseno");
            return (Criteria) this;
        }

        public Criteria andPurchasenoGreaterThanOrEqualTo(String value) {
            addCriterion("PURCHASENO >=", value, "purchaseno");
            return (Criteria) this;
        }

        public Criteria andPurchasenoLessThan(String value) {
            addCriterion("PURCHASENO <", value, "purchaseno");
            return (Criteria) this;
        }

        public Criteria andPurchasenoLessThanOrEqualTo(String value) {
            addCriterion("PURCHASENO <=", value, "purchaseno");
            return (Criteria) this;
        }

        public Criteria andPurchasenoLike(String value) {
            addCriterion("PURCHASENO like", value, "purchaseno");
            return (Criteria) this;
        }

        public Criteria andPurchasenoNotLike(String value) {
            addCriterion("PURCHASENO not like", value, "purchaseno");
            return (Criteria) this;
        }

        public Criteria andPurchasenoIn(List<String> values) {
            addCriterion("PURCHASENO in", values, "purchaseno");
            return (Criteria) this;
        }

        public Criteria andPurchasenoNotIn(List<String> values) {
            addCriterion("PURCHASENO not in", values, "purchaseno");
            return (Criteria) this;
        }

        public Criteria andPurchasenoBetween(String value1, String value2) {
            addCriterion("PURCHASENO between", value1, value2, "purchaseno");
            return (Criteria) this;
        }

        public Criteria andPurchasenoNotBetween(String value1, String value2) {
            addCriterion("PURCHASENO not between", value1, value2, "purchaseno");
            return (Criteria) this;
        }

        public Criteria andShopidIsNull() {
            addCriterion("shopid is null");
            return (Criteria) this;
        }

        public Criteria andShopidIsNotNull() {
            addCriterion("shopid is not null");
            return (Criteria) this;
        }

        public Criteria andShopidEqualTo(String value) {
            addCriterion("shopid =", value, "shopid");
            return (Criteria) this;
        }

        public Criteria andShopidNotEqualTo(String value) {
            addCriterion("shopid <>", value, "shopid");
            return (Criteria) this;
        }

        public Criteria andShopidGreaterThan(String value) {
            addCriterion("shopid >", value, "shopid");
            return (Criteria) this;
        }

        public Criteria andShopidGreaterThanOrEqualTo(String value) {
            addCriterion("shopid >=", value, "shopid");
            return (Criteria) this;
        }

        public Criteria andShopidLessThan(String value) {
            addCriterion("shopid <", value, "shopid");
            return (Criteria) this;
        }

        public Criteria andShopidLessThanOrEqualTo(String value) {
            addCriterion("shopid <=", value, "shopid");
            return (Criteria) this;
        }

        public Criteria andShopidLike(String value) {
            addCriterion("shopid like", value, "shopid");
            return (Criteria) this;
        }

        public Criteria andShopidNotLike(String value) {
            addCriterion("shopid not like", value, "shopid");
            return (Criteria) this;
        }

        public Criteria andShopidIn(List<String> values) {
            addCriterion("shopid in", values, "shopid");
            return (Criteria) this;
        }

        public Criteria andShopidNotIn(List<String> values) {
            addCriterion("shopid not in", values, "shopid");
            return (Criteria) this;
        }

        public Criteria andShopidBetween(String value1, String value2) {
            addCriterion("shopid between", value1, value2, "shopid");
            return (Criteria) this;
        }

        public Criteria andShopidNotBetween(String value1, String value2) {
            addCriterion("shopid not between", value1, value2, "shopid");
            return (Criteria) this;
        }

        public Criteria andPlacecdIsNull() {
            addCriterion("PLACECD is null");
            return (Criteria) this;
        }

        public Criteria andPlacecdIsNotNull() {
            addCriterion("PLACECD is not null");
            return (Criteria) this;
        }

        public Criteria andPlacecdEqualTo(String value) {
            addCriterion("PLACECD =", value, "placecd");
            return (Criteria) this;
        }

        public Criteria andPlacecdNotEqualTo(String value) {
            addCriterion("PLACECD <>", value, "placecd");
            return (Criteria) this;
        }

        public Criteria andPlacecdGreaterThan(String value) {
            addCriterion("PLACECD >", value, "placecd");
            return (Criteria) this;
        }

        public Criteria andPlacecdGreaterThanOrEqualTo(String value) {
            addCriterion("PLACECD >=", value, "placecd");
            return (Criteria) this;
        }

        public Criteria andPlacecdLessThan(String value) {
            addCriterion("PLACECD <", value, "placecd");
            return (Criteria) this;
        }

        public Criteria andPlacecdLessThanOrEqualTo(String value) {
            addCriterion("PLACECD <=", value, "placecd");
            return (Criteria) this;
        }

        public Criteria andPlacecdLike(String value) {
            addCriterion("PLACECD like", value, "placecd");
            return (Criteria) this;
        }

        public Criteria andPlacecdNotLike(String value) {
            addCriterion("PLACECD not like", value, "placecd");
            return (Criteria) this;
        }

        public Criteria andPlacecdIn(List<String> values) {
            addCriterion("PLACECD in", values, "placecd");
            return (Criteria) this;
        }

        public Criteria andPlacecdNotIn(List<String> values) {
            addCriterion("PLACECD not in", values, "placecd");
            return (Criteria) this;
        }

        public Criteria andPlacecdBetween(String value1, String value2) {
            addCriterion("PLACECD between", value1, value2, "placecd");
            return (Criteria) this;
        }

        public Criteria andPlacecdNotBetween(String value1, String value2) {
            addCriterion("PLACECD not between", value1, value2, "placecd");
            return (Criteria) this;
        }

        public Criteria andTicketnoIsNull() {
            addCriterion("TICKETNO is null");
            return (Criteria) this;
        }

        public Criteria andTicketnoIsNotNull() {
            addCriterion("TICKETNO is not null");
            return (Criteria) this;
        }

        public Criteria andTicketnoEqualTo(String value) {
            addCriterion("TICKETNO =", value, "ticketno");
            return (Criteria) this;
        }

        public Criteria andTicketnoNotEqualTo(String value) {
            addCriterion("TICKETNO <>", value, "ticketno");
            return (Criteria) this;
        }

        public Criteria andTicketnoGreaterThan(String value) {
            addCriterion("TICKETNO >", value, "ticketno");
            return (Criteria) this;
        }

        public Criteria andTicketnoGreaterThanOrEqualTo(String value) {
            addCriterion("TICKETNO >=", value, "ticketno");
            return (Criteria) this;
        }

        public Criteria andTicketnoLessThan(String value) {
            addCriterion("TICKETNO <", value, "ticketno");
            return (Criteria) this;
        }

        public Criteria andTicketnoLessThanOrEqualTo(String value) {
            addCriterion("TICKETNO <=", value, "ticketno");
            return (Criteria) this;
        }

        public Criteria andTicketnoLike(String value) {
            addCriterion("TICKETNO like", value, "ticketno");
            return (Criteria) this;
        }

        public Criteria andTicketnoNotLike(String value) {
            addCriterion("TICKETNO not like", value, "ticketno");
            return (Criteria) this;
        }

        public Criteria andTicketnoIn(List<String> values) {
            addCriterion("TICKETNO in", values, "ticketno");
            return (Criteria) this;
        }

        public Criteria andTicketnoNotIn(List<String> values) {
            addCriterion("TICKETNO not in", values, "ticketno");
            return (Criteria) this;
        }

        public Criteria andTicketnoBetween(String value1, String value2) {
            addCriterion("TICKETNO between", value1, value2, "ticketno");
            return (Criteria) this;
        }

        public Criteria andTicketnoNotBetween(String value1, String value2) {
            addCriterion("TICKETNO not between", value1, value2, "ticketno");
            return (Criteria) this;
        }

        public Criteria andTicketymdIsNull() {
            addCriterion("TICKETYMD is null");
            return (Criteria) this;
        }

        public Criteria andTicketymdIsNotNull() {
            addCriterion("TICKETYMD is not null");
            return (Criteria) this;
        }

        public Criteria andTicketymdEqualTo(String value) {
            addCriterion("TICKETYMD =", value, "ticketymd");
            return (Criteria) this;
        }

        public Criteria andTicketymdNotEqualTo(String value) {
            addCriterion("TICKETYMD <>", value, "ticketymd");
            return (Criteria) this;
        }

        public Criteria andTicketymdGreaterThan(String value) {
            addCriterion("TICKETYMD >", value, "ticketymd");
            return (Criteria) this;
        }

        public Criteria andTicketymdGreaterThanOrEqualTo(String value) {
            addCriterion("TICKETYMD >=", value, "ticketymd");
            return (Criteria) this;
        }

        public Criteria andTicketymdLessThan(String value) {
            addCriterion("TICKETYMD <", value, "ticketymd");
            return (Criteria) this;
        }

        public Criteria andTicketymdLessThanOrEqualTo(String value) {
            addCriterion("TICKETYMD <=", value, "ticketymd");
            return (Criteria) this;
        }

        public Criteria andTicketymdLike(String value) {
            addCriterion("TICKETYMD like", value, "ticketymd");
            return (Criteria) this;
        }

        public Criteria andTicketymdNotLike(String value) {
            addCriterion("TICKETYMD not like", value, "ticketymd");
            return (Criteria) this;
        }

        public Criteria andTicketymdIn(List<String> values) {
            addCriterion("TICKETYMD in", values, "ticketymd");
            return (Criteria) this;
        }

        public Criteria andTicketymdNotIn(List<String> values) {
            addCriterion("TICKETYMD not in", values, "ticketymd");
            return (Criteria) this;
        }

        public Criteria andTicketymdBetween(String value1, String value2) {
            addCriterion("TICKETYMD between", value1, value2, "ticketymd");
            return (Criteria) this;
        }

        public Criteria andTicketymdNotBetween(String value1, String value2) {
            addCriterion("TICKETYMD not between", value1, value2, "ticketymd");
            return (Criteria) this;
        }

        public Criteria andTotalmnyIsNull() {
            addCriterion("TOTALMNY is null");
            return (Criteria) this;
        }

        public Criteria andTotalmnyIsNotNull() {
            addCriterion("TOTALMNY is not null");
            return (Criteria) this;
        }

        public Criteria andTotalmnyEqualTo(BigDecimal value) {
            addCriterion("TOTALMNY =", value, "totalmny");
            return (Criteria) this;
        }

        public Criteria andTotalmnyNotEqualTo(BigDecimal value) {
            addCriterion("TOTALMNY <>", value, "totalmny");
            return (Criteria) this;
        }

        public Criteria andTotalmnyGreaterThan(BigDecimal value) {
            addCriterion("TOTALMNY >", value, "totalmny");
            return (Criteria) this;
        }

        public Criteria andTotalmnyGreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("TOTALMNY >=", value, "totalmny");
            return (Criteria) this;
        }

        public Criteria andTotalmnyLessThan(BigDecimal value) {
            addCriterion("TOTALMNY <", value, "totalmny");
            return (Criteria) this;
        }

        public Criteria andTotalmnyLessThanOrEqualTo(BigDecimal value) {
            addCriterion("TOTALMNY <=", value, "totalmny");
            return (Criteria) this;
        }

        public Criteria andTotalmnyIn(List<BigDecimal> values) {
            addCriterion("TOTALMNY in", values, "totalmny");
            return (Criteria) this;
        }

        public Criteria andTotalmnyNotIn(List<BigDecimal> values) {
            addCriterion("TOTALMNY not in", values, "totalmny");
            return (Criteria) this;
        }

        public Criteria andTotalmnyBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("TOTALMNY between", value1, value2, "totalmny");
            return (Criteria) this;
        }

        public Criteria andTotalmnyNotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("TOTALMNY not between", value1, value2, "totalmny");
            return (Criteria) this;
        }

        public Criteria andOrdermnyIsNull() {
            addCriterion("ORDERMNY is null");
            return (Criteria) this;
        }

        public Criteria andOrdermnyIsNotNull() {
            addCriterion("ORDERMNY is not null");
            return (Criteria) this;
        }

        public Criteria andOrdermnyEqualTo(BigDecimal value) {
            addCriterion("ORDERMNY =", value, "ordermny");
            return (Criteria) this;
        }

        public Criteria andOrdermnyNotEqualTo(BigDecimal value) {
            addCriterion("ORDERMNY <>", value, "ordermny");
            return (Criteria) this;
        }

        public Criteria andOrdermnyGreaterThan(BigDecimal value) {
            addCriterion("ORDERMNY >", value, "ordermny");
            return (Criteria) this;
        }

        public Criteria andOrdermnyGreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("ORDERMNY >=", value, "ordermny");
            return (Criteria) this;
        }

        public Criteria andOrdermnyLessThan(BigDecimal value) {
            addCriterion("ORDERMNY <", value, "ordermny");
            return (Criteria) this;
        }

        public Criteria andOrdermnyLessThanOrEqualTo(BigDecimal value) {
            addCriterion("ORDERMNY <=", value, "ordermny");
            return (Criteria) this;
        }

        public Criteria andOrdermnyIn(List<BigDecimal> values) {
            addCriterion("ORDERMNY in", values, "ordermny");
            return (Criteria) this;
        }

        public Criteria andOrdermnyNotIn(List<BigDecimal> values) {
            addCriterion("ORDERMNY not in", values, "ordermny");
            return (Criteria) this;
        }

        public Criteria andOrdermnyBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("ORDERMNY between", value1, value2, "ordermny");
            return (Criteria) this;
        }

        public Criteria andOrdermnyNotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("ORDERMNY not between", value1, value2, "ordermny");
            return (Criteria) this;
        }

        public Criteria andPurchaseflgIsNull() {
            addCriterion("PurchaseFlg is null");
            return (Criteria) this;
        }

        public Criteria andPurchaseflgIsNotNull() {
            addCriterion("PurchaseFlg is not null");
            return (Criteria) this;
        }

        public Criteria andPurchaseflgEqualTo(String value) {
            addCriterion("PurchaseFlg =", value, "purchaseflg");
            return (Criteria) this;
        }

        public Criteria andPurchaseflgNotEqualTo(String value) {
            addCriterion("PurchaseFlg <>", value, "purchaseflg");
            return (Criteria) this;
        }

        public Criteria andPurchaseflgGreaterThan(String value) {
            addCriterion("PurchaseFlg >", value, "purchaseflg");
            return (Criteria) this;
        }

        public Criteria andPurchaseflgGreaterThanOrEqualTo(String value) {
            addCriterion("PurchaseFlg >=", value, "purchaseflg");
            return (Criteria) this;
        }

        public Criteria andPurchaseflgLessThan(String value) {
            addCriterion("PurchaseFlg <", value, "purchaseflg");
            return (Criteria) this;
        }

        public Criteria andPurchaseflgLessThanOrEqualTo(String value) {
            addCriterion("PurchaseFlg <=", value, "purchaseflg");
            return (Criteria) this;
        }

        public Criteria andPurchaseflgLike(String value) {
            addCriterion("PurchaseFlg like", value, "purchaseflg");
            return (Criteria) this;
        }

        public Criteria andPurchaseflgNotLike(String value) {
            addCriterion("PurchaseFlg not like", value, "purchaseflg");
            return (Criteria) this;
        }

        public Criteria andPurchaseflgIn(List<String> values) {
            addCriterion("PurchaseFlg in", values, "purchaseflg");
            return (Criteria) this;
        }

        public Criteria andPurchaseflgNotIn(List<String> values) {
            addCriterion("PurchaseFlg not in", values, "purchaseflg");
            return (Criteria) this;
        }

        public Criteria andPurchaseflgBetween(String value1, String value2) {
            addCriterion("PurchaseFlg between", value1, value2, "purchaseflg");
            return (Criteria) this;
        }

        public Criteria andPurchaseflgNotBetween(String value1, String value2) {
            addCriterion("PurchaseFlg not between", value1, value2, "purchaseflg");
            return (Criteria) this;
        }

        public Criteria andSupplycdIsNull() {
            addCriterion("SUPPLYCD is null");
            return (Criteria) this;
        }

        public Criteria andSupplycdIsNotNull() {
            addCriterion("SUPPLYCD is not null");
            return (Criteria) this;
        }

        public Criteria andSupplycdEqualTo(String value) {
            addCriterion("SUPPLYCD =", value, "supplycd");
            return (Criteria) this;
        }

        public Criteria andSupplycdNotEqualTo(String value) {
            addCriterion("SUPPLYCD <>", value, "supplycd");
            return (Criteria) this;
        }

        public Criteria andSupplycdGreaterThan(String value) {
            addCriterion("SUPPLYCD >", value, "supplycd");
            return (Criteria) this;
        }

        public Criteria andSupplycdGreaterThanOrEqualTo(String value) {
            addCriterion("SUPPLYCD >=", value, "supplycd");
            return (Criteria) this;
        }

        public Criteria andSupplycdLessThan(String value) {
            addCriterion("SUPPLYCD <", value, "supplycd");
            return (Criteria) this;
        }

        public Criteria andSupplycdLessThanOrEqualTo(String value) {
            addCriterion("SUPPLYCD <=", value, "supplycd");
            return (Criteria) this;
        }

        public Criteria andSupplycdLike(String value) {
            addCriterion("SUPPLYCD like", value, "supplycd");
            return (Criteria) this;
        }

        public Criteria andSupplycdNotLike(String value) {
            addCriterion("SUPPLYCD not like", value, "supplycd");
            return (Criteria) this;
        }

        public Criteria andSupplycdIn(List<String> values) {
            addCriterion("SUPPLYCD in", values, "supplycd");
            return (Criteria) this;
        }

        public Criteria andSupplycdNotIn(List<String> values) {
            addCriterion("SUPPLYCD not in", values, "supplycd");
            return (Criteria) this;
        }

        public Criteria andSupplycdBetween(String value1, String value2) {
            addCriterion("SUPPLYCD between", value1, value2, "supplycd");
            return (Criteria) this;
        }

        public Criteria andSupplycdNotBetween(String value1, String value2) {
            addCriterion("SUPPLYCD not between", value1, value2, "supplycd");
            return (Criteria) this;
        }

        public Criteria andSecondsplyflgIsNull() {
            addCriterion("SecondSplyFlg is null");
            return (Criteria) this;
        }

        public Criteria andSecondsplyflgIsNotNull() {
            addCriterion("SecondSplyFlg is not null");
            return (Criteria) this;
        }

        public Criteria andSecondsplyflgEqualTo(String value) {
            addCriterion("SecondSplyFlg =", value, "secondsplyflg");
            return (Criteria) this;
        }

        public Criteria andSecondsplyflgNotEqualTo(String value) {
            addCriterion("SecondSplyFlg <>", value, "secondsplyflg");
            return (Criteria) this;
        }

        public Criteria andSecondsplyflgGreaterThan(String value) {
            addCriterion("SecondSplyFlg >", value, "secondsplyflg");
            return (Criteria) this;
        }

        public Criteria andSecondsplyflgGreaterThanOrEqualTo(String value) {
            addCriterion("SecondSplyFlg >=", value, "secondsplyflg");
            return (Criteria) this;
        }

        public Criteria andSecondsplyflgLessThan(String value) {
            addCriterion("SecondSplyFlg <", value, "secondsplyflg");
            return (Criteria) this;
        }

        public Criteria andSecondsplyflgLessThanOrEqualTo(String value) {
            addCriterion("SecondSplyFlg <=", value, "secondsplyflg");
            return (Criteria) this;
        }

        public Criteria andSecondsplyflgLike(String value) {
            addCriterion("SecondSplyFlg like", value, "secondsplyflg");
            return (Criteria) this;
        }

        public Criteria andSecondsplyflgNotLike(String value) {
            addCriterion("SecondSplyFlg not like", value, "secondsplyflg");
            return (Criteria) this;
        }

        public Criteria andSecondsplyflgIn(List<String> values) {
            addCriterion("SecondSplyFlg in", values, "secondsplyflg");
            return (Criteria) this;
        }

        public Criteria andSecondsplyflgNotIn(List<String> values) {
            addCriterion("SecondSplyFlg not in", values, "secondsplyflg");
            return (Criteria) this;
        }

        public Criteria andSecondsplyflgBetween(String value1, String value2) {
            addCriterion("SecondSplyFlg between", value1, value2, "secondsplyflg");
            return (Criteria) this;
        }

        public Criteria andSecondsplyflgNotBetween(String value1, String value2) {
            addCriterion("SecondSplyFlg not between", value1, value2, "secondsplyflg");
            return (Criteria) this;
        }

        public Criteria andDescdIsNull() {
            addCriterion("DESCD is null");
            return (Criteria) this;
        }

        public Criteria andDescdIsNotNull() {
            addCriterion("DESCD is not null");
            return (Criteria) this;
        }

        public Criteria andDescdEqualTo(String value) {
            addCriterion("DESCD =", value, "descd");
            return (Criteria) this;
        }

        public Criteria andDescdNotEqualTo(String value) {
            addCriterion("DESCD <>", value, "descd");
            return (Criteria) this;
        }

        public Criteria andDescdGreaterThan(String value) {
            addCriterion("DESCD >", value, "descd");
            return (Criteria) this;
        }

        public Criteria andDescdGreaterThanOrEqualTo(String value) {
            addCriterion("DESCD >=", value, "descd");
            return (Criteria) this;
        }

        public Criteria andDescdLessThan(String value) {
            addCriterion("DESCD <", value, "descd");
            return (Criteria) this;
        }

        public Criteria andDescdLessThanOrEqualTo(String value) {
            addCriterion("DESCD <=", value, "descd");
            return (Criteria) this;
        }

        public Criteria andDescdLike(String value) {
            addCriterion("DESCD like", value, "descd");
            return (Criteria) this;
        }

        public Criteria andDescdNotLike(String value) {
            addCriterion("DESCD not like", value, "descd");
            return (Criteria) this;
        }

        public Criteria andDescdIn(List<String> values) {
            addCriterion("DESCD in", values, "descd");
            return (Criteria) this;
        }

        public Criteria andDescdNotIn(List<String> values) {
            addCriterion("DESCD not in", values, "descd");
            return (Criteria) this;
        }

        public Criteria andDescdBetween(String value1, String value2) {
            addCriterion("DESCD between", value1, value2, "descd");
            return (Criteria) this;
        }

        public Criteria andDescdNotBetween(String value1, String value2) {
            addCriterion("DESCD not between", value1, value2, "descd");
            return (Criteria) this;
        }

        public Criteria andInstockflgIsNull() {
            addCriterion("INSTOCKFLG is null");
            return (Criteria) this;
        }

        public Criteria andInstockflgIsNotNull() {
            addCriterion("INSTOCKFLG is not null");
            return (Criteria) this;
        }

        public Criteria andInstockflgEqualTo(String value) {
            addCriterion("INSTOCKFLG =", value, "instockflg");
            return (Criteria) this;
        }

        public Criteria andInstockflgNotEqualTo(String value) {
            addCriterion("INSTOCKFLG <>", value, "instockflg");
            return (Criteria) this;
        }

        public Criteria andInstockflgGreaterThan(String value) {
            addCriterion("INSTOCKFLG >", value, "instockflg");
            return (Criteria) this;
        }

        public Criteria andInstockflgGreaterThanOrEqualTo(String value) {
            addCriterion("INSTOCKFLG >=", value, "instockflg");
            return (Criteria) this;
        }

        public Criteria andInstockflgLessThan(String value) {
            addCriterion("INSTOCKFLG <", value, "instockflg");
            return (Criteria) this;
        }

        public Criteria andInstockflgLessThanOrEqualTo(String value) {
            addCriterion("INSTOCKFLG <=", value, "instockflg");
            return (Criteria) this;
        }

        public Criteria andInstockflgLike(String value) {
            addCriterion("INSTOCKFLG like", value, "instockflg");
            return (Criteria) this;
        }

        public Criteria andInstockflgNotLike(String value) {
            addCriterion("INSTOCKFLG not like", value, "instockflg");
            return (Criteria) this;
        }

        public Criteria andInstockflgIn(List<String> values) {
            addCriterion("INSTOCKFLG in", values, "instockflg");
            return (Criteria) this;
        }

        public Criteria andInstockflgNotIn(List<String> values) {
            addCriterion("INSTOCKFLG not in", values, "instockflg");
            return (Criteria) this;
        }

        public Criteria andInstockflgBetween(String value1, String value2) {
            addCriterion("INSTOCKFLG between", value1, value2, "instockflg");
            return (Criteria) this;
        }

        public Criteria andInstockflgNotBetween(String value1, String value2) {
            addCriterion("INSTOCKFLG not between", value1, value2, "instockflg");
            return (Criteria) this;
        }

        public Criteria andTransporttypeIsNull() {
            addCriterion("TRANSPORTTYPE is null");
            return (Criteria) this;
        }

        public Criteria andTransporttypeIsNotNull() {
            addCriterion("TRANSPORTTYPE is not null");
            return (Criteria) this;
        }

        public Criteria andTransporttypeEqualTo(String value) {
            addCriterion("TRANSPORTTYPE =", value, "transporttype");
            return (Criteria) this;
        }

        public Criteria andTransporttypeNotEqualTo(String value) {
            addCriterion("TRANSPORTTYPE <>", value, "transporttype");
            return (Criteria) this;
        }

        public Criteria andTransporttypeGreaterThan(String value) {
            addCriterion("TRANSPORTTYPE >", value, "transporttype");
            return (Criteria) this;
        }

        public Criteria andTransporttypeGreaterThanOrEqualTo(String value) {
            addCriterion("TRANSPORTTYPE >=", value, "transporttype");
            return (Criteria) this;
        }

        public Criteria andTransporttypeLessThan(String value) {
            addCriterion("TRANSPORTTYPE <", value, "transporttype");
            return (Criteria) this;
        }

        public Criteria andTransporttypeLessThanOrEqualTo(String value) {
            addCriterion("TRANSPORTTYPE <=", value, "transporttype");
            return (Criteria) this;
        }

        public Criteria andTransporttypeLike(String value) {
            addCriterion("TRANSPORTTYPE like", value, "transporttype");
            return (Criteria) this;
        }

        public Criteria andTransporttypeNotLike(String value) {
            addCriterion("TRANSPORTTYPE not like", value, "transporttype");
            return (Criteria) this;
        }

        public Criteria andTransporttypeIn(List<String> values) {
            addCriterion("TRANSPORTTYPE in", values, "transporttype");
            return (Criteria) this;
        }

        public Criteria andTransporttypeNotIn(List<String> values) {
            addCriterion("TRANSPORTTYPE not in", values, "transporttype");
            return (Criteria) this;
        }

        public Criteria andTransporttypeBetween(String value1, String value2) {
            addCriterion("TRANSPORTTYPE between", value1, value2, "transporttype");
            return (Criteria) this;
        }

        public Criteria andTransporttypeNotBetween(String value1, String value2) {
            addCriterion("TRANSPORTTYPE not between", value1, value2, "transporttype");
            return (Criteria) this;
        }

        public Criteria andTransportfeeIsNull() {
            addCriterion("TransportFee is null");
            return (Criteria) this;
        }

        public Criteria andTransportfeeIsNotNull() {
            addCriterion("TransportFee is not null");
            return (Criteria) this;
        }

        public Criteria andTransportfeeEqualTo(BigDecimal value) {
            addCriterion("TransportFee =", value, "transportfee");
            return (Criteria) this;
        }

        public Criteria andTransportfeeNotEqualTo(BigDecimal value) {
            addCriterion("TransportFee <>", value, "transportfee");
            return (Criteria) this;
        }

        public Criteria andTransportfeeGreaterThan(BigDecimal value) {
            addCriterion("TransportFee >", value, "transportfee");
            return (Criteria) this;
        }

        public Criteria andTransportfeeGreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("TransportFee >=", value, "transportfee");
            return (Criteria) this;
        }

        public Criteria andTransportfeeLessThan(BigDecimal value) {
            addCriterion("TransportFee <", value, "transportfee");
            return (Criteria) this;
        }

        public Criteria andTransportfeeLessThanOrEqualTo(BigDecimal value) {
            addCriterion("TransportFee <=", value, "transportfee");
            return (Criteria) this;
        }

        public Criteria andTransportfeeIn(List<BigDecimal> values) {
            addCriterion("TransportFee in", values, "transportfee");
            return (Criteria) this;
        }

        public Criteria andTransportfeeNotIn(List<BigDecimal> values) {
            addCriterion("TransportFee not in", values, "transportfee");
            return (Criteria) this;
        }

        public Criteria andTransportfeeBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("TransportFee between", value1, value2, "transportfee");
            return (Criteria) this;
        }

        public Criteria andTransportfeeNotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("TransportFee not between", value1, value2, "transportfee");
            return (Criteria) this;
        }

        public Criteria andTransportfeekbnIsNull() {
            addCriterion("TransportFeeKBN is null");
            return (Criteria) this;
        }

        public Criteria andTransportfeekbnIsNotNull() {
            addCriterion("TransportFeeKBN is not null");
            return (Criteria) this;
        }

        public Criteria andTransportfeekbnEqualTo(String value) {
            addCriterion("TransportFeeKBN =", value, "transportfeekbn");
            return (Criteria) this;
        }

        public Criteria andTransportfeekbnNotEqualTo(String value) {
            addCriterion("TransportFeeKBN <>", value, "transportfeekbn");
            return (Criteria) this;
        }

        public Criteria andTransportfeekbnGreaterThan(String value) {
            addCriterion("TransportFeeKBN >", value, "transportfeekbn");
            return (Criteria) this;
        }

        public Criteria andTransportfeekbnGreaterThanOrEqualTo(String value) {
            addCriterion("TransportFeeKBN >=", value, "transportfeekbn");
            return (Criteria) this;
        }

        public Criteria andTransportfeekbnLessThan(String value) {
            addCriterion("TransportFeeKBN <", value, "transportfeekbn");
            return (Criteria) this;
        }

        public Criteria andTransportfeekbnLessThanOrEqualTo(String value) {
            addCriterion("TransportFeeKBN <=", value, "transportfeekbn");
            return (Criteria) this;
        }

        public Criteria andTransportfeekbnLike(String value) {
            addCriterion("TransportFeeKBN like", value, "transportfeekbn");
            return (Criteria) this;
        }

        public Criteria andTransportfeekbnNotLike(String value) {
            addCriterion("TransportFeeKBN not like", value, "transportfeekbn");
            return (Criteria) this;
        }

        public Criteria andTransportfeekbnIn(List<String> values) {
            addCriterion("TransportFeeKBN in", values, "transportfeekbn");
            return (Criteria) this;
        }

        public Criteria andTransportfeekbnNotIn(List<String> values) {
            addCriterion("TransportFeeKBN not in", values, "transportfeekbn");
            return (Criteria) this;
        }

        public Criteria andTransportfeekbnBetween(String value1, String value2) {
            addCriterion("TransportFeeKBN between", value1, value2, "transportfeekbn");
            return (Criteria) this;
        }

        public Criteria andTransportfeekbnNotBetween(String value1, String value2) {
            addCriterion("TransportFeeKBN not between", value1, value2, "transportfeekbn");
            return (Criteria) this;
        }

        public Criteria andCurrencycdIsNull() {
            addCriterion("CURRENCYCD is null");
            return (Criteria) this;
        }

        public Criteria andCurrencycdIsNotNull() {
            addCriterion("CURRENCYCD is not null");
            return (Criteria) this;
        }

        public Criteria andCurrencycdEqualTo(String value) {
            addCriterion("CURRENCYCD =", value, "currencycd");
            return (Criteria) this;
        }

        public Criteria andCurrencycdNotEqualTo(String value) {
            addCriterion("CURRENCYCD <>", value, "currencycd");
            return (Criteria) this;
        }

        public Criteria andCurrencycdGreaterThan(String value) {
            addCriterion("CURRENCYCD >", value, "currencycd");
            return (Criteria) this;
        }

        public Criteria andCurrencycdGreaterThanOrEqualTo(String value) {
            addCriterion("CURRENCYCD >=", value, "currencycd");
            return (Criteria) this;
        }

        public Criteria andCurrencycdLessThan(String value) {
            addCriterion("CURRENCYCD <", value, "currencycd");
            return (Criteria) this;
        }

        public Criteria andCurrencycdLessThanOrEqualTo(String value) {
            addCriterion("CURRENCYCD <=", value, "currencycd");
            return (Criteria) this;
        }

        public Criteria andCurrencycdLike(String value) {
            addCriterion("CURRENCYCD like", value, "currencycd");
            return (Criteria) this;
        }

        public Criteria andCurrencycdNotLike(String value) {
            addCriterion("CURRENCYCD not like", value, "currencycd");
            return (Criteria) this;
        }

        public Criteria andCurrencycdIn(List<String> values) {
            addCriterion("CURRENCYCD in", values, "currencycd");
            return (Criteria) this;
        }

        public Criteria andCurrencycdNotIn(List<String> values) {
            addCriterion("CURRENCYCD not in", values, "currencycd");
            return (Criteria) this;
        }

        public Criteria andCurrencycdBetween(String value1, String value2) {
            addCriterion("CURRENCYCD between", value1, value2, "currencycd");
            return (Criteria) this;
        }

        public Criteria andCurrencycdNotBetween(String value1, String value2) {
            addCriterion("CURRENCYCD not between", value1, value2, "currencycd");
            return (Criteria) this;
        }

        public Criteria andOrderstatusIsNull() {
            addCriterion("ORDERSTATUS is null");
            return (Criteria) this;
        }

        public Criteria andOrderstatusIsNotNull() {
            addCriterion("ORDERSTATUS is not null");
            return (Criteria) this;
        }

        public Criteria andOrderstatusEqualTo(String value) {
            addCriterion("ORDERSTATUS =", value, "orderstatus");
            return (Criteria) this;
        }

        public Criteria andOrderstatusNotEqualTo(String value) {
            addCriterion("ORDERSTATUS <>", value, "orderstatus");
            return (Criteria) this;
        }

        public Criteria andOrderstatusGreaterThan(String value) {
            addCriterion("ORDERSTATUS >", value, "orderstatus");
            return (Criteria) this;
        }

        public Criteria andOrderstatusGreaterThanOrEqualTo(String value) {
            addCriterion("ORDERSTATUS >=", value, "orderstatus");
            return (Criteria) this;
        }

        public Criteria andOrderstatusLessThan(String value) {
            addCriterion("ORDERSTATUS <", value, "orderstatus");
            return (Criteria) this;
        }

        public Criteria andOrderstatusLessThanOrEqualTo(String value) {
            addCriterion("ORDERSTATUS <=", value, "orderstatus");
            return (Criteria) this;
        }

        public Criteria andOrderstatusLike(String value) {
            addCriterion("ORDERSTATUS like", value, "orderstatus");
            return (Criteria) this;
        }

        public Criteria andOrderstatusNotLike(String value) {
            addCriterion("ORDERSTATUS not like", value, "orderstatus");
            return (Criteria) this;
        }

        public Criteria andOrderstatusIn(List<String> values) {
            addCriterion("ORDERSTATUS in", values, "orderstatus");
            return (Criteria) this;
        }

        public Criteria andOrderstatusNotIn(List<String> values) {
            addCriterion("ORDERSTATUS not in", values, "orderstatus");
            return (Criteria) this;
        }

        public Criteria andOrderstatusBetween(String value1, String value2) {
            addCriterion("ORDERSTATUS between", value1, value2, "orderstatus");
            return (Criteria) this;
        }

        public Criteria andOrderstatusNotBetween(String value1, String value2) {
            addCriterion("ORDERSTATUS not between", value1, value2, "orderstatus");
            return (Criteria) this;
        }

        public Criteria andPurchaseymdIsNull() {
            addCriterion("PURCHASEYMD is null");
            return (Criteria) this;
        }

        public Criteria andPurchaseymdIsNotNull() {
            addCriterion("PURCHASEYMD is not null");
            return (Criteria) this;
        }

        public Criteria andPurchaseymdEqualTo(String value) {
            addCriterion("PURCHASEYMD =", value, "purchaseymd");
            return (Criteria) this;
        }

        public Criteria andPurchaseymdNotEqualTo(String value) {
            addCriterion("PURCHASEYMD <>", value, "purchaseymd");
            return (Criteria) this;
        }

        public Criteria andPurchaseymdGreaterThan(String value) {
            addCriterion("PURCHASEYMD >", value, "purchaseymd");
            return (Criteria) this;
        }

        public Criteria andPurchaseymdGreaterThanOrEqualTo(String value) {
            addCriterion("PURCHASEYMD >=", value, "purchaseymd");
            return (Criteria) this;
        }

        public Criteria andPurchaseymdLessThan(String value) {
            addCriterion("PURCHASEYMD <", value, "purchaseymd");
            return (Criteria) this;
        }

        public Criteria andPurchaseymdLessThanOrEqualTo(String value) {
            addCriterion("PURCHASEYMD <=", value, "purchaseymd");
            return (Criteria) this;
        }

        public Criteria andPurchaseymdLike(String value) {
            addCriterion("PURCHASEYMD like", value, "purchaseymd");
            return (Criteria) this;
        }

        public Criteria andPurchaseymdNotLike(String value) {
            addCriterion("PURCHASEYMD not like", value, "purchaseymd");
            return (Criteria) this;
        }

        public Criteria andPurchaseymdIn(List<String> values) {
            addCriterion("PURCHASEYMD in", values, "purchaseymd");
            return (Criteria) this;
        }

        public Criteria andPurchaseymdNotIn(List<String> values) {
            addCriterion("PURCHASEYMD not in", values, "purchaseymd");
            return (Criteria) this;
        }

        public Criteria andPurchaseymdBetween(String value1, String value2) {
            addCriterion("PURCHASEYMD between", value1, value2, "purchaseymd");
            return (Criteria) this;
        }

        public Criteria andPurchaseymdNotBetween(String value1, String value2) {
            addCriterion("PURCHASEYMD not between", value1, value2, "purchaseymd");
            return (Criteria) this;
        }

        public Criteria andInstockymdIsNull() {
            addCriterion("INSTOCKYMD is null");
            return (Criteria) this;
        }

        public Criteria andInstockymdIsNotNull() {
            addCriterion("INSTOCKYMD is not null");
            return (Criteria) this;
        }

        public Criteria andInstockymdEqualTo(String value) {
            addCriterion("INSTOCKYMD =", value, "instockymd");
            return (Criteria) this;
        }

        public Criteria andInstockymdNotEqualTo(String value) {
            addCriterion("INSTOCKYMD <>", value, "instockymd");
            return (Criteria) this;
        }

        public Criteria andInstockymdGreaterThan(String value) {
            addCriterion("INSTOCKYMD >", value, "instockymd");
            return (Criteria) this;
        }

        public Criteria andInstockymdGreaterThanOrEqualTo(String value) {
            addCriterion("INSTOCKYMD >=", value, "instockymd");
            return (Criteria) this;
        }

        public Criteria andInstockymdLessThan(String value) {
            addCriterion("INSTOCKYMD <", value, "instockymd");
            return (Criteria) this;
        }

        public Criteria andInstockymdLessThanOrEqualTo(String value) {
            addCriterion("INSTOCKYMD <=", value, "instockymd");
            return (Criteria) this;
        }

        public Criteria andInstockymdLike(String value) {
            addCriterion("INSTOCKYMD like", value, "instockymd");
            return (Criteria) this;
        }

        public Criteria andInstockymdNotLike(String value) {
            addCriterion("INSTOCKYMD not like", value, "instockymd");
            return (Criteria) this;
        }

        public Criteria andInstockymdIn(List<String> values) {
            addCriterion("INSTOCKYMD in", values, "instockymd");
            return (Criteria) this;
        }

        public Criteria andInstockymdNotIn(List<String> values) {
            addCriterion("INSTOCKYMD not in", values, "instockymd");
            return (Criteria) this;
        }

        public Criteria andInstockymdBetween(String value1, String value2) {
            addCriterion("INSTOCKYMD between", value1, value2, "instockymd");
            return (Criteria) this;
        }

        public Criteria andInstockymdNotBetween(String value1, String value2) {
            addCriterion("INSTOCKYMD not between", value1, value2, "instockymd");
            return (Criteria) this;
        }

        public Criteria andPlaninstcymdIsNull() {
            addCriterion("PlanInstcYMD is null");
            return (Criteria) this;
        }

        public Criteria andPlaninstcymdIsNotNull() {
            addCriterion("PlanInstcYMD is not null");
            return (Criteria) this;
        }

        public Criteria andPlaninstcymdEqualTo(String value) {
            addCriterion("PlanInstcYMD =", value, "planinstcymd");
            return (Criteria) this;
        }

        public Criteria andPlaninstcymdNotEqualTo(String value) {
            addCriterion("PlanInstcYMD <>", value, "planinstcymd");
            return (Criteria) this;
        }

        public Criteria andPlaninstcymdGreaterThan(String value) {
            addCriterion("PlanInstcYMD >", value, "planinstcymd");
            return (Criteria) this;
        }

        public Criteria andPlaninstcymdGreaterThanOrEqualTo(String value) {
            addCriterion("PlanInstcYMD >=", value, "planinstcymd");
            return (Criteria) this;
        }

        public Criteria andPlaninstcymdLessThan(String value) {
            addCriterion("PlanInstcYMD <", value, "planinstcymd");
            return (Criteria) this;
        }

        public Criteria andPlaninstcymdLessThanOrEqualTo(String value) {
            addCriterion("PlanInstcYMD <=", value, "planinstcymd");
            return (Criteria) this;
        }

        public Criteria andPlaninstcymdLike(String value) {
            addCriterion("PlanInstcYMD like", value, "planinstcymd");
            return (Criteria) this;
        }

        public Criteria andPlaninstcymdNotLike(String value) {
            addCriterion("PlanInstcYMD not like", value, "planinstcymd");
            return (Criteria) this;
        }

        public Criteria andPlaninstcymdIn(List<String> values) {
            addCriterion("PlanInstcYMD in", values, "planinstcymd");
            return (Criteria) this;
        }

        public Criteria andPlaninstcymdNotIn(List<String> values) {
            addCriterion("PlanInstcYMD not in", values, "planinstcymd");
            return (Criteria) this;
        }

        public Criteria andPlaninstcymdBetween(String value1, String value2) {
            addCriterion("PlanInstcYMD between", value1, value2, "planinstcymd");
            return (Criteria) this;
        }

        public Criteria andPlaninstcymdNotBetween(String value1, String value2) {
            addCriterion("PlanInstcYMD not between", value1, value2, "planinstcymd");
            return (Criteria) this;
        }

        public Criteria andCustconfirmymdIsNull() {
            addCriterion("CustConfirmYMD is null");
            return (Criteria) this;
        }

        public Criteria andCustconfirmymdIsNotNull() {
            addCriterion("CustConfirmYMD is not null");
            return (Criteria) this;
        }

        public Criteria andCustconfirmymdEqualTo(String value) {
            addCriterion("CustConfirmYMD =", value, "custconfirmymd");
            return (Criteria) this;
        }

        public Criteria andCustconfirmymdNotEqualTo(String value) {
            addCriterion("CustConfirmYMD <>", value, "custconfirmymd");
            return (Criteria) this;
        }

        public Criteria andCustconfirmymdGreaterThan(String value) {
            addCriterion("CustConfirmYMD >", value, "custconfirmymd");
            return (Criteria) this;
        }

        public Criteria andCustconfirmymdGreaterThanOrEqualTo(String value) {
            addCriterion("CustConfirmYMD >=", value, "custconfirmymd");
            return (Criteria) this;
        }

        public Criteria andCustconfirmymdLessThan(String value) {
            addCriterion("CustConfirmYMD <", value, "custconfirmymd");
            return (Criteria) this;
        }

        public Criteria andCustconfirmymdLessThanOrEqualTo(String value) {
            addCriterion("CustConfirmYMD <=", value, "custconfirmymd");
            return (Criteria) this;
        }

        public Criteria andCustconfirmymdLike(String value) {
            addCriterion("CustConfirmYMD like", value, "custconfirmymd");
            return (Criteria) this;
        }

        public Criteria andCustconfirmymdNotLike(String value) {
            addCriterion("CustConfirmYMD not like", value, "custconfirmymd");
            return (Criteria) this;
        }

        public Criteria andCustconfirmymdIn(List<String> values) {
            addCriterion("CustConfirmYMD in", values, "custconfirmymd");
            return (Criteria) this;
        }

        public Criteria andCustconfirmymdNotIn(List<String> values) {
            addCriterion("CustConfirmYMD not in", values, "custconfirmymd");
            return (Criteria) this;
        }

        public Criteria andCustconfirmymdBetween(String value1, String value2) {
            addCriterion("CustConfirmYMD between", value1, value2, "custconfirmymd");
            return (Criteria) this;
        }

        public Criteria andCustconfirmymdNotBetween(String value1, String value2) {
            addCriterion("CustConfirmYMD not between", value1, value2, "custconfirmymd");
            return (Criteria) this;
        }

        public Criteria andPurchasemanIsNull() {
            addCriterion("PURCHASEMAN is null");
            return (Criteria) this;
        }

        public Criteria andPurchasemanIsNotNull() {
            addCriterion("PURCHASEMAN is not null");
            return (Criteria) this;
        }

        public Criteria andPurchasemanEqualTo(String value) {
            addCriterion("PURCHASEMAN =", value, "purchaseman");
            return (Criteria) this;
        }

        public Criteria andPurchasemanNotEqualTo(String value) {
            addCriterion("PURCHASEMAN <>", value, "purchaseman");
            return (Criteria) this;
        }

        public Criteria andPurchasemanGreaterThan(String value) {
            addCriterion("PURCHASEMAN >", value, "purchaseman");
            return (Criteria) this;
        }

        public Criteria andPurchasemanGreaterThanOrEqualTo(String value) {
            addCriterion("PURCHASEMAN >=", value, "purchaseman");
            return (Criteria) this;
        }

        public Criteria andPurchasemanLessThan(String value) {
            addCriterion("PURCHASEMAN <", value, "purchaseman");
            return (Criteria) this;
        }

        public Criteria andPurchasemanLessThanOrEqualTo(String value) {
            addCriterion("PURCHASEMAN <=", value, "purchaseman");
            return (Criteria) this;
        }

        public Criteria andPurchasemanLike(String value) {
            addCriterion("PURCHASEMAN like", value, "purchaseman");
            return (Criteria) this;
        }

        public Criteria andPurchasemanNotLike(String value) {
            addCriterion("PURCHASEMAN not like", value, "purchaseman");
            return (Criteria) this;
        }

        public Criteria andPurchasemanIn(List<String> values) {
            addCriterion("PURCHASEMAN in", values, "purchaseman");
            return (Criteria) this;
        }

        public Criteria andPurchasemanNotIn(List<String> values) {
            addCriterion("PURCHASEMAN not in", values, "purchaseman");
            return (Criteria) this;
        }

        public Criteria andPurchasemanBetween(String value1, String value2) {
            addCriterion("PURCHASEMAN between", value1, value2, "purchaseman");
            return (Criteria) this;
        }

        public Criteria andPurchasemanNotBetween(String value1, String value2) {
            addCriterion("PURCHASEMAN not between", value1, value2, "purchaseman");
            return (Criteria) this;
        }

        public Criteria andInstockmanIsNull() {
            addCriterion("INSTOCKMAN is null");
            return (Criteria) this;
        }

        public Criteria andInstockmanIsNotNull() {
            addCriterion("INSTOCKMAN is not null");
            return (Criteria) this;
        }

        public Criteria andInstockmanEqualTo(String value) {
            addCriterion("INSTOCKMAN =", value, "instockman");
            return (Criteria) this;
        }

        public Criteria andInstockmanNotEqualTo(String value) {
            addCriterion("INSTOCKMAN <>", value, "instockman");
            return (Criteria) this;
        }

        public Criteria andInstockmanGreaterThan(String value) {
            addCriterion("INSTOCKMAN >", value, "instockman");
            return (Criteria) this;
        }

        public Criteria andInstockmanGreaterThanOrEqualTo(String value) {
            addCriterion("INSTOCKMAN >=", value, "instockman");
            return (Criteria) this;
        }

        public Criteria andInstockmanLessThan(String value) {
            addCriterion("INSTOCKMAN <", value, "instockman");
            return (Criteria) this;
        }

        public Criteria andInstockmanLessThanOrEqualTo(String value) {
            addCriterion("INSTOCKMAN <=", value, "instockman");
            return (Criteria) this;
        }

        public Criteria andInstockmanLike(String value) {
            addCriterion("INSTOCKMAN like", value, "instockman");
            return (Criteria) this;
        }

        public Criteria andInstockmanNotLike(String value) {
            addCriterion("INSTOCKMAN not like", value, "instockman");
            return (Criteria) this;
        }

        public Criteria andInstockmanIn(List<String> values) {
            addCriterion("INSTOCKMAN in", values, "instockman");
            return (Criteria) this;
        }

        public Criteria andInstockmanNotIn(List<String> values) {
            addCriterion("INSTOCKMAN not in", values, "instockman");
            return (Criteria) this;
        }

        public Criteria andInstockmanBetween(String value1, String value2) {
            addCriterion("INSTOCKMAN between", value1, value2, "instockman");
            return (Criteria) this;
        }

        public Criteria andInstockmanNotBetween(String value1, String value2) {
            addCriterion("INSTOCKMAN not between", value1, value2, "instockman");
            return (Criteria) this;
        }

        public Criteria andActionflgIsNull() {
            addCriterion("ACTIONFLG is null");
            return (Criteria) this;
        }

        public Criteria andActionflgIsNotNull() {
            addCriterion("ACTIONFLG is not null");
            return (Criteria) this;
        }

        public Criteria andActionflgEqualTo(String value) {
            addCriterion("ACTIONFLG =", value, "actionflg");
            return (Criteria) this;
        }

        public Criteria andActionflgNotEqualTo(String value) {
            addCriterion("ACTIONFLG <>", value, "actionflg");
            return (Criteria) this;
        }

        public Criteria andActionflgGreaterThan(String value) {
            addCriterion("ACTIONFLG >", value, "actionflg");
            return (Criteria) this;
        }

        public Criteria andActionflgGreaterThanOrEqualTo(String value) {
            addCriterion("ACTIONFLG >=", value, "actionflg");
            return (Criteria) this;
        }

        public Criteria andActionflgLessThan(String value) {
            addCriterion("ACTIONFLG <", value, "actionflg");
            return (Criteria) this;
        }

        public Criteria andActionflgLessThanOrEqualTo(String value) {
            addCriterion("ACTIONFLG <=", value, "actionflg");
            return (Criteria) this;
        }

        public Criteria andActionflgLike(String value) {
            addCriterion("ACTIONFLG like", value, "actionflg");
            return (Criteria) this;
        }

        public Criteria andActionflgNotLike(String value) {
            addCriterion("ACTIONFLG not like", value, "actionflg");
            return (Criteria) this;
        }

        public Criteria andActionflgIn(List<String> values) {
            addCriterion("ACTIONFLG in", values, "actionflg");
            return (Criteria) this;
        }

        public Criteria andActionflgNotIn(List<String> values) {
            addCriterion("ACTIONFLG not in", values, "actionflg");
            return (Criteria) this;
        }

        public Criteria andActionflgBetween(String value1, String value2) {
            addCriterion("ACTIONFLG between", value1, value2, "actionflg");
            return (Criteria) this;
        }

        public Criteria andActionflgNotBetween(String value1, String value2) {
            addCriterion("ACTIONFLG not between", value1, value2, "actionflg");
            return (Criteria) this;
        }

        public Criteria andPrintflgIsNull() {
            addCriterion("PRINTFLG is null");
            return (Criteria) this;
        }

        public Criteria andPrintflgIsNotNull() {
            addCriterion("PRINTFLG is not null");
            return (Criteria) this;
        }

        public Criteria andPrintflgEqualTo(String value) {
            addCriterion("PRINTFLG =", value, "printflg");
            return (Criteria) this;
        }

        public Criteria andPrintflgNotEqualTo(String value) {
            addCriterion("PRINTFLG <>", value, "printflg");
            return (Criteria) this;
        }

        public Criteria andPrintflgGreaterThan(String value) {
            addCriterion("PRINTFLG >", value, "printflg");
            return (Criteria) this;
        }

        public Criteria andPrintflgGreaterThanOrEqualTo(String value) {
            addCriterion("PRINTFLG >=", value, "printflg");
            return (Criteria) this;
        }

        public Criteria andPrintflgLessThan(String value) {
            addCriterion("PRINTFLG <", value, "printflg");
            return (Criteria) this;
        }

        public Criteria andPrintflgLessThanOrEqualTo(String value) {
            addCriterion("PRINTFLG <=", value, "printflg");
            return (Criteria) this;
        }

        public Criteria andPrintflgLike(String value) {
            addCriterion("PRINTFLG like", value, "printflg");
            return (Criteria) this;
        }

        public Criteria andPrintflgNotLike(String value) {
            addCriterion("PRINTFLG not like", value, "printflg");
            return (Criteria) this;
        }

        public Criteria andPrintflgIn(List<String> values) {
            addCriterion("PRINTFLG in", values, "printflg");
            return (Criteria) this;
        }

        public Criteria andPrintflgNotIn(List<String> values) {
            addCriterion("PRINTFLG not in", values, "printflg");
            return (Criteria) this;
        }

        public Criteria andPrintflgBetween(String value1, String value2) {
            addCriterion("PRINTFLG between", value1, value2, "printflg");
            return (Criteria) this;
        }

        public Criteria andPrintflgNotBetween(String value1, String value2) {
            addCriterion("PRINTFLG not between", value1, value2, "printflg");
            return (Criteria) this;
        }

        public Criteria andPrintymdIsNull() {
            addCriterion("PRINTYMD is null");
            return (Criteria) this;
        }

        public Criteria andPrintymdIsNotNull() {
            addCriterion("PRINTYMD is not null");
            return (Criteria) this;
        }

        public Criteria andPrintymdEqualTo(String value) {
            addCriterion("PRINTYMD =", value, "printymd");
            return (Criteria) this;
        }

        public Criteria andPrintymdNotEqualTo(String value) {
            addCriterion("PRINTYMD <>", value, "printymd");
            return (Criteria) this;
        }

        public Criteria andPrintymdGreaterThan(String value) {
            addCriterion("PRINTYMD >", value, "printymd");
            return (Criteria) this;
        }

        public Criteria andPrintymdGreaterThanOrEqualTo(String value) {
            addCriterion("PRINTYMD >=", value, "printymd");
            return (Criteria) this;
        }

        public Criteria andPrintymdLessThan(String value) {
            addCriterion("PRINTYMD <", value, "printymd");
            return (Criteria) this;
        }

        public Criteria andPrintymdLessThanOrEqualTo(String value) {
            addCriterion("PRINTYMD <=", value, "printymd");
            return (Criteria) this;
        }

        public Criteria andPrintymdLike(String value) {
            addCriterion("PRINTYMD like", value, "printymd");
            return (Criteria) this;
        }

        public Criteria andPrintymdNotLike(String value) {
            addCriterion("PRINTYMD not like", value, "printymd");
            return (Criteria) this;
        }

        public Criteria andPrintymdIn(List<String> values) {
            addCriterion("PRINTYMD in", values, "printymd");
            return (Criteria) this;
        }

        public Criteria andPrintymdNotIn(List<String> values) {
            addCriterion("PRINTYMD not in", values, "printymd");
            return (Criteria) this;
        }

        public Criteria andPrintymdBetween(String value1, String value2) {
            addCriterion("PRINTYMD between", value1, value2, "printymd");
            return (Criteria) this;
        }

        public Criteria andPrintymdNotBetween(String value1, String value2) {
            addCriterion("PRINTYMD not between", value1, value2, "printymd");
            return (Criteria) this;
        }

        public Criteria andPrintmanIsNull() {
            addCriterion("PRINTMAN is null");
            return (Criteria) this;
        }

        public Criteria andPrintmanIsNotNull() {
            addCriterion("PRINTMAN is not null");
            return (Criteria) this;
        }

        public Criteria andPrintmanEqualTo(String value) {
            addCriterion("PRINTMAN =", value, "printman");
            return (Criteria) this;
        }

        public Criteria andPrintmanNotEqualTo(String value) {
            addCriterion("PRINTMAN <>", value, "printman");
            return (Criteria) this;
        }

        public Criteria andPrintmanGreaterThan(String value) {
            addCriterion("PRINTMAN >", value, "printman");
            return (Criteria) this;
        }

        public Criteria andPrintmanGreaterThanOrEqualTo(String value) {
            addCriterion("PRINTMAN >=", value, "printman");
            return (Criteria) this;
        }

        public Criteria andPrintmanLessThan(String value) {
            addCriterion("PRINTMAN <", value, "printman");
            return (Criteria) this;
        }

        public Criteria andPrintmanLessThanOrEqualTo(String value) {
            addCriterion("PRINTMAN <=", value, "printman");
            return (Criteria) this;
        }

        public Criteria andPrintmanLike(String value) {
            addCriterion("PRINTMAN like", value, "printman");
            return (Criteria) this;
        }

        public Criteria andPrintmanNotLike(String value) {
            addCriterion("PRINTMAN not like", value, "printman");
            return (Criteria) this;
        }

        public Criteria andPrintmanIn(List<String> values) {
            addCriterion("PRINTMAN in", values, "printman");
            return (Criteria) this;
        }

        public Criteria andPrintmanNotIn(List<String> values) {
            addCriterion("PRINTMAN not in", values, "printman");
            return (Criteria) this;
        }

        public Criteria andPrintmanBetween(String value1, String value2) {
            addCriterion("PRINTMAN between", value1, value2, "printman");
            return (Criteria) this;
        }

        public Criteria andPrintmanNotBetween(String value1, String value2) {
            addCriterion("PRINTMAN not between", value1, value2, "printman");
            return (Criteria) this;
        }

        public Criteria andMemoIsNull() {
            addCriterion("MEMO is null");
            return (Criteria) this;
        }

        public Criteria andMemoIsNotNull() {
            addCriterion("MEMO is not null");
            return (Criteria) this;
        }

        public Criteria andMemoEqualTo(String value) {
            addCriterion("MEMO =", value, "memo");
            return (Criteria) this;
        }

        public Criteria andMemoNotEqualTo(String value) {
            addCriterion("MEMO <>", value, "memo");
            return (Criteria) this;
        }

        public Criteria andMemoGreaterThan(String value) {
            addCriterion("MEMO >", value, "memo");
            return (Criteria) this;
        }

        public Criteria andMemoGreaterThanOrEqualTo(String value) {
            addCriterion("MEMO >=", value, "memo");
            return (Criteria) this;
        }

        public Criteria andMemoLessThan(String value) {
            addCriterion("MEMO <", value, "memo");
            return (Criteria) this;
        }

        public Criteria andMemoLessThanOrEqualTo(String value) {
            addCriterion("MEMO <=", value, "memo");
            return (Criteria) this;
        }

        public Criteria andMemoLike(String value) {
            addCriterion("MEMO like", value, "memo");
            return (Criteria) this;
        }

        public Criteria andMemoNotLike(String value) {
            addCriterion("MEMO not like", value, "memo");
            return (Criteria) this;
        }

        public Criteria andMemoIn(List<String> values) {
            addCriterion("MEMO in", values, "memo");
            return (Criteria) this;
        }

        public Criteria andMemoNotIn(List<String> values) {
            addCriterion("MEMO not in", values, "memo");
            return (Criteria) this;
        }

        public Criteria andMemoBetween(String value1, String value2) {
            addCriterion("MEMO between", value1, value2, "memo");
            return (Criteria) this;
        }

        public Criteria andMemoNotBetween(String value1, String value2) {
            addCriterion("MEMO not between", value1, value2, "memo");
            return (Criteria) this;
        }

        public Criteria andUpdatetimeIsNull() {
            addCriterion("UPDATETIME is null");
            return (Criteria) this;
        }

        public Criteria andUpdatetimeIsNotNull() {
            addCriterion("UPDATETIME is not null");
            return (Criteria) this;
        }

        public Criteria andUpdatetimeEqualTo(Date value) {
            addCriterionForJDBCDate("UPDATETIME =", value, "updatetime");
            return (Criteria) this;
        }

        public Criteria andUpdatetimeNotEqualTo(Date value) {
            addCriterionForJDBCDate("UPDATETIME <>", value, "updatetime");
            return (Criteria) this;
        }

        public Criteria andUpdatetimeGreaterThan(Date value) {
            addCriterionForJDBCDate("UPDATETIME >", value, "updatetime");
            return (Criteria) this;
        }

        public Criteria andUpdatetimeGreaterThanOrEqualTo(Date value) {
            addCriterionForJDBCDate("UPDATETIME >=", value, "updatetime");
            return (Criteria) this;
        }

        public Criteria andUpdatetimeLessThan(Date value) {
            addCriterionForJDBCDate("UPDATETIME <", value, "updatetime");
            return (Criteria) this;
        }

        public Criteria andUpdatetimeLessThanOrEqualTo(Date value) {
            addCriterionForJDBCDate("UPDATETIME <=", value, "updatetime");
            return (Criteria) this;
        }

        public Criteria andUpdatetimeIn(List<Date> values) {
            addCriterionForJDBCDate("UPDATETIME in", values, "updatetime");
            return (Criteria) this;
        }

        public Criteria andUpdatetimeNotIn(List<Date> values) {
            addCriterionForJDBCDate("UPDATETIME not in", values, "updatetime");
            return (Criteria) this;
        }

        public Criteria andUpdatetimeBetween(Date value1, Date value2) {
            addCriterionForJDBCDate("UPDATETIME between", value1, value2, "updatetime");
            return (Criteria) this;
        }

        public Criteria andUpdatetimeNotBetween(Date value1, Date value2) {
            addCriterionForJDBCDate("UPDATETIME not between", value1, value2, "updatetime");
            return (Criteria) this;
        }

        public Criteria andUpdatemanIsNull() {
            addCriterion("UPDATEMAN is null");
            return (Criteria) this;
        }

        public Criteria andUpdatemanIsNotNull() {
            addCriterion("UPDATEMAN is not null");
            return (Criteria) this;
        }

        public Criteria andUpdatemanEqualTo(String value) {
            addCriterion("UPDATEMAN =", value, "updateman");
            return (Criteria) this;
        }

        public Criteria andUpdatemanNotEqualTo(String value) {
            addCriterion("UPDATEMAN <>", value, "updateman");
            return (Criteria) this;
        }

        public Criteria andUpdatemanGreaterThan(String value) {
            addCriterion("UPDATEMAN >", value, "updateman");
            return (Criteria) this;
        }

        public Criteria andUpdatemanGreaterThanOrEqualTo(String value) {
            addCriterion("UPDATEMAN >=", value, "updateman");
            return (Criteria) this;
        }

        public Criteria andUpdatemanLessThan(String value) {
            addCriterion("UPDATEMAN <", value, "updateman");
            return (Criteria) this;
        }

        public Criteria andUpdatemanLessThanOrEqualTo(String value) {
            addCriterion("UPDATEMAN <=", value, "updateman");
            return (Criteria) this;
        }

        public Criteria andUpdatemanLike(String value) {
            addCriterion("UPDATEMAN like", value, "updateman");
            return (Criteria) this;
        }

        public Criteria andUpdatemanNotLike(String value) {
            addCriterion("UPDATEMAN not like", value, "updateman");
            return (Criteria) this;
        }

        public Criteria andUpdatemanIn(List<String> values) {
            addCriterion("UPDATEMAN in", values, "updateman");
            return (Criteria) this;
        }

        public Criteria andUpdatemanNotIn(List<String> values) {
            addCriterion("UPDATEMAN not in", values, "updateman");
            return (Criteria) this;
        }

        public Criteria andUpdatemanBetween(String value1, String value2) {
            addCriterion("UPDATEMAN between", value1, value2, "updateman");
            return (Criteria) this;
        }

        public Criteria andUpdatemanNotBetween(String value1, String value2) {
            addCriterion("UPDATEMAN not between", value1, value2, "updateman");
            return (Criteria) this;
        }

        public Criteria andRtnflgIsNull() {
            addCriterion("RtnFlg is null");
            return (Criteria) this;
        }

        public Criteria andRtnflgIsNotNull() {
            addCriterion("RtnFlg is not null");
            return (Criteria) this;
        }

        public Criteria andRtnflgEqualTo(String value) {
            addCriterion("RtnFlg =", value, "rtnflg");
            return (Criteria) this;
        }

        public Criteria andRtnflgNotEqualTo(String value) {
            addCriterion("RtnFlg <>", value, "rtnflg");
            return (Criteria) this;
        }

        public Criteria andRtnflgGreaterThan(String value) {
            addCriterion("RtnFlg >", value, "rtnflg");
            return (Criteria) this;
        }

        public Criteria andRtnflgGreaterThanOrEqualTo(String value) {
            addCriterion("RtnFlg >=", value, "rtnflg");
            return (Criteria) this;
        }

        public Criteria andRtnflgLessThan(String value) {
            addCriterion("RtnFlg <", value, "rtnflg");
            return (Criteria) this;
        }

        public Criteria andRtnflgLessThanOrEqualTo(String value) {
            addCriterion("RtnFlg <=", value, "rtnflg");
            return (Criteria) this;
        }

        public Criteria andRtnflgLike(String value) {
            addCriterion("RtnFlg like", value, "rtnflg");
            return (Criteria) this;
        }

        public Criteria andRtnflgNotLike(String value) {
            addCriterion("RtnFlg not like", value, "rtnflg");
            return (Criteria) this;
        }

        public Criteria andRtnflgIn(List<String> values) {
            addCriterion("RtnFlg in", values, "rtnflg");
            return (Criteria) this;
        }

        public Criteria andRtnflgNotIn(List<String> values) {
            addCriterion("RtnFlg not in", values, "rtnflg");
            return (Criteria) this;
        }

        public Criteria andRtnflgBetween(String value1, String value2) {
            addCriterion("RtnFlg between", value1, value2, "rtnflg");
            return (Criteria) this;
        }

        public Criteria andRtnflgNotBetween(String value1, String value2) {
            addCriterion("RtnFlg not between", value1, value2, "rtnflg");
            return (Criteria) this;
        }

        public Criteria andRtnymdIsNull() {
            addCriterion("RtnYMD is null");
            return (Criteria) this;
        }

        public Criteria andRtnymdIsNotNull() {
            addCriterion("RtnYMD is not null");
            return (Criteria) this;
        }

        public Criteria andRtnymdEqualTo(String value) {
            addCriterion("RtnYMD =", value, "rtnymd");
            return (Criteria) this;
        }

        public Criteria andRtnymdNotEqualTo(String value) {
            addCriterion("RtnYMD <>", value, "rtnymd");
            return (Criteria) this;
        }

        public Criteria andRtnymdGreaterThan(String value) {
            addCriterion("RtnYMD >", value, "rtnymd");
            return (Criteria) this;
        }

        public Criteria andRtnymdGreaterThanOrEqualTo(String value) {
            addCriterion("RtnYMD >=", value, "rtnymd");
            return (Criteria) this;
        }

        public Criteria andRtnymdLessThan(String value) {
            addCriterion("RtnYMD <", value, "rtnymd");
            return (Criteria) this;
        }

        public Criteria andRtnymdLessThanOrEqualTo(String value) {
            addCriterion("RtnYMD <=", value, "rtnymd");
            return (Criteria) this;
        }

        public Criteria andRtnymdLike(String value) {
            addCriterion("RtnYMD like", value, "rtnymd");
            return (Criteria) this;
        }

        public Criteria andRtnymdNotLike(String value) {
            addCriterion("RtnYMD not like", value, "rtnymd");
            return (Criteria) this;
        }

        public Criteria andRtnymdIn(List<String> values) {
            addCriterion("RtnYMD in", values, "rtnymd");
            return (Criteria) this;
        }

        public Criteria andRtnymdNotIn(List<String> values) {
            addCriterion("RtnYMD not in", values, "rtnymd");
            return (Criteria) this;
        }

        public Criteria andRtnymdBetween(String value1, String value2) {
            addCriterion("RtnYMD between", value1, value2, "rtnymd");
            return (Criteria) this;
        }

        public Criteria andRtnymdNotBetween(String value1, String value2) {
            addCriterion("RtnYMD not between", value1, value2, "rtnymd");
            return (Criteria) this;
        }

        public Criteria andRtntotalmnyIsNull() {
            addCriterion("RtnTotalMny is null");
            return (Criteria) this;
        }

        public Criteria andRtntotalmnyIsNotNull() {
            addCriterion("RtnTotalMny is not null");
            return (Criteria) this;
        }

        public Criteria andRtntotalmnyEqualTo(BigDecimal value) {
            addCriterion("RtnTotalMny =", value, "rtntotalmny");
            return (Criteria) this;
        }

        public Criteria andRtntotalmnyNotEqualTo(BigDecimal value) {
            addCriterion("RtnTotalMny <>", value, "rtntotalmny");
            return (Criteria) this;
        }

        public Criteria andRtntotalmnyGreaterThan(BigDecimal value) {
            addCriterion("RtnTotalMny >", value, "rtntotalmny");
            return (Criteria) this;
        }

        public Criteria andRtntotalmnyGreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("RtnTotalMny >=", value, "rtntotalmny");
            return (Criteria) this;
        }

        public Criteria andRtntotalmnyLessThan(BigDecimal value) {
            addCriterion("RtnTotalMny <", value, "rtntotalmny");
            return (Criteria) this;
        }

        public Criteria andRtntotalmnyLessThanOrEqualTo(BigDecimal value) {
            addCriterion("RtnTotalMny <=", value, "rtntotalmny");
            return (Criteria) this;
        }

        public Criteria andRtntotalmnyIn(List<BigDecimal> values) {
            addCriterion("RtnTotalMny in", values, "rtntotalmny");
            return (Criteria) this;
        }

        public Criteria andRtntotalmnyNotIn(List<BigDecimal> values) {
            addCriterion("RtnTotalMny not in", values, "rtntotalmny");
            return (Criteria) this;
        }

        public Criteria andRtntotalmnyBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("RtnTotalMny between", value1, value2, "rtntotalmny");
            return (Criteria) this;
        }

        public Criteria andRtntotalmnyNotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("RtnTotalMny not between", value1, value2, "rtntotalmny");
            return (Criteria) this;
        }

        public Criteria andProductioncdIsNull() {
            addCriterion("ProductionCD is null");
            return (Criteria) this;
        }

        public Criteria andProductioncdIsNotNull() {
            addCriterion("ProductionCD is not null");
            return (Criteria) this;
        }

        public Criteria andProductioncdEqualTo(String value) {
            addCriterion("ProductionCD =", value, "productioncd");
            return (Criteria) this;
        }

        public Criteria andProductioncdNotEqualTo(String value) {
            addCriterion("ProductionCD <>", value, "productioncd");
            return (Criteria) this;
        }

        public Criteria andProductioncdGreaterThan(String value) {
            addCriterion("ProductionCD >", value, "productioncd");
            return (Criteria) this;
        }

        public Criteria andProductioncdGreaterThanOrEqualTo(String value) {
            addCriterion("ProductionCD >=", value, "productioncd");
            return (Criteria) this;
        }

        public Criteria andProductioncdLessThan(String value) {
            addCriterion("ProductionCD <", value, "productioncd");
            return (Criteria) this;
        }

        public Criteria andProductioncdLessThanOrEqualTo(String value) {
            addCriterion("ProductionCD <=", value, "productioncd");
            return (Criteria) this;
        }

        public Criteria andProductioncdLike(String value) {
            addCriterion("ProductionCD like", value, "productioncd");
            return (Criteria) this;
        }

        public Criteria andProductioncdNotLike(String value) {
            addCriterion("ProductionCD not like", value, "productioncd");
            return (Criteria) this;
        }

        public Criteria andProductioncdIn(List<String> values) {
            addCriterion("ProductionCD in", values, "productioncd");
            return (Criteria) this;
        }

        public Criteria andProductioncdNotIn(List<String> values) {
            addCriterion("ProductionCD not in", values, "productioncd");
            return (Criteria) this;
        }

        public Criteria andProductioncdBetween(String value1, String value2) {
            addCriterion("ProductionCD between", value1, value2, "productioncd");
            return (Criteria) this;
        }

        public Criteria andProductioncdNotBetween(String value1, String value2) {
            addCriterion("ProductionCD not between", value1, value2, "productioncd");
            return (Criteria) this;
        }

        public Criteria andCustordflgIsNull() {
            addCriterion("CustOrdFlg is null");
            return (Criteria) this;
        }

        public Criteria andCustordflgIsNotNull() {
            addCriterion("CustOrdFlg is not null");
            return (Criteria) this;
        }

        public Criteria andCustordflgEqualTo(String value) {
            addCriterion("CustOrdFlg =", value, "custordflg");
            return (Criteria) this;
        }

        public Criteria andCustordflgNotEqualTo(String value) {
            addCriterion("CustOrdFlg <>", value, "custordflg");
            return (Criteria) this;
        }

        public Criteria andCustordflgGreaterThan(String value) {
            addCriterion("CustOrdFlg >", value, "custordflg");
            return (Criteria) this;
        }

        public Criteria andCustordflgGreaterThanOrEqualTo(String value) {
            addCriterion("CustOrdFlg >=", value, "custordflg");
            return (Criteria) this;
        }

        public Criteria andCustordflgLessThan(String value) {
            addCriterion("CustOrdFlg <", value, "custordflg");
            return (Criteria) this;
        }

        public Criteria andCustordflgLessThanOrEqualTo(String value) {
            addCriterion("CustOrdFlg <=", value, "custordflg");
            return (Criteria) this;
        }

        public Criteria andCustordflgLike(String value) {
            addCriterion("CustOrdFlg like", value, "custordflg");
            return (Criteria) this;
        }

        public Criteria andCustordflgNotLike(String value) {
            addCriterion("CustOrdFlg not like", value, "custordflg");
            return (Criteria) this;
        }

        public Criteria andCustordflgIn(List<String> values) {
            addCriterion("CustOrdFlg in", values, "custordflg");
            return (Criteria) this;
        }

        public Criteria andCustordflgNotIn(List<String> values) {
            addCriterion("CustOrdFlg not in", values, "custordflg");
            return (Criteria) this;
        }

        public Criteria andCustordflgBetween(String value1, String value2) {
            addCriterion("CustOrdFlg between", value1, value2, "custordflg");
            return (Criteria) this;
        }

        public Criteria andCustordflgNotBetween(String value1, String value2) {
            addCriterion("CustOrdFlg not between", value1, value2, "custordflg");
            return (Criteria) this;
        }

        public Criteria andSyncflgIsNull() {
            addCriterion("SYNCFLG is null");
            return (Criteria) this;
        }

        public Criteria andSyncflgIsNotNull() {
            addCriterion("SYNCFLG is not null");
            return (Criteria) this;
        }

        public Criteria andSyncflgEqualTo(String value) {
            addCriterion("SYNCFLG =", value, "syncflg");
            return (Criteria) this;
        }

        public Criteria andSyncflgNotEqualTo(String value) {
            addCriterion("SYNCFLG <>", value, "syncflg");
            return (Criteria) this;
        }

        public Criteria andSyncflgGreaterThan(String value) {
            addCriterion("SYNCFLG >", value, "syncflg");
            return (Criteria) this;
        }

        public Criteria andSyncflgGreaterThanOrEqualTo(String value) {
            addCriterion("SYNCFLG >=", value, "syncflg");
            return (Criteria) this;
        }

        public Criteria andSyncflgLessThan(String value) {
            addCriterion("SYNCFLG <", value, "syncflg");
            return (Criteria) this;
        }

        public Criteria andSyncflgLessThanOrEqualTo(String value) {
            addCriterion("SYNCFLG <=", value, "syncflg");
            return (Criteria) this;
        }

        public Criteria andSyncflgLike(String value) {
            addCriterion("SYNCFLG like", value, "syncflg");
            return (Criteria) this;
        }

        public Criteria andSyncflgNotLike(String value) {
            addCriterion("SYNCFLG not like", value, "syncflg");
            return (Criteria) this;
        }

        public Criteria andSyncflgIn(List<String> values) {
            addCriterion("SYNCFLG in", values, "syncflg");
            return (Criteria) this;
        }

        public Criteria andSyncflgNotIn(List<String> values) {
            addCriterion("SYNCFLG not in", values, "syncflg");
            return (Criteria) this;
        }

        public Criteria andSyncflgBetween(String value1, String value2) {
            addCriterion("SYNCFLG between", value1, value2, "syncflg");
            return (Criteria) this;
        }

        public Criteria andSyncflgNotBetween(String value1, String value2) {
            addCriterion("SYNCFLG not between", value1, value2, "syncflg");
            return (Criteria) this;
        }

        public Criteria andSynctimeIsNull() {
            addCriterion("SYNCTIME is null");
            return (Criteria) this;
        }

        public Criteria andSynctimeIsNotNull() {
            addCriterion("SYNCTIME is not null");
            return (Criteria) this;
        }

        public Criteria andSynctimeEqualTo(Date value) {
            addCriterionForJDBCDate("SYNCTIME =", value, "synctime");
            return (Criteria) this;
        }

        public Criteria andSynctimeNotEqualTo(Date value) {
            addCriterionForJDBCDate("SYNCTIME <>", value, "synctime");
            return (Criteria) this;
        }

        public Criteria andSynctimeGreaterThan(Date value) {
            addCriterionForJDBCDate("SYNCTIME >", value, "synctime");
            return (Criteria) this;
        }

        public Criteria andSynctimeGreaterThanOrEqualTo(Date value) {
            addCriterionForJDBCDate("SYNCTIME >=", value, "synctime");
            return (Criteria) this;
        }

        public Criteria andSynctimeLessThan(Date value) {
            addCriterionForJDBCDate("SYNCTIME <", value, "synctime");
            return (Criteria) this;
        }

        public Criteria andSynctimeLessThanOrEqualTo(Date value) {
            addCriterionForJDBCDate("SYNCTIME <=", value, "synctime");
            return (Criteria) this;
        }

        public Criteria andSynctimeIn(List<Date> values) {
            addCriterionForJDBCDate("SYNCTIME in", values, "synctime");
            return (Criteria) this;
        }

        public Criteria andSynctimeNotIn(List<Date> values) {
            addCriterionForJDBCDate("SYNCTIME not in", values, "synctime");
            return (Criteria) this;
        }

        public Criteria andSynctimeBetween(Date value1, Date value2) {
            addCriterionForJDBCDate("SYNCTIME between", value1, value2, "synctime");
            return (Criteria) this;
        }

        public Criteria andSynctimeNotBetween(Date value1, Date value2) {
            addCriterionForJDBCDate("SYNCTIME not between", value1, value2, "synctime");
            return (Criteria) this;
        }

        public Criteria andSubsellflgIsNull() {
            addCriterion("SubSellFlg is null");
            return (Criteria) this;
        }

        public Criteria andSubsellflgIsNotNull() {
            addCriterion("SubSellFlg is not null");
            return (Criteria) this;
        }

        public Criteria andSubsellflgEqualTo(String value) {
            addCriterion("SubSellFlg =", value, "subsellflg");
            return (Criteria) this;
        }

        public Criteria andSubsellflgNotEqualTo(String value) {
            addCriterion("SubSellFlg <>", value, "subsellflg");
            return (Criteria) this;
        }

        public Criteria andSubsellflgGreaterThan(String value) {
            addCriterion("SubSellFlg >", value, "subsellflg");
            return (Criteria) this;
        }

        public Criteria andSubsellflgGreaterThanOrEqualTo(String value) {
            addCriterion("SubSellFlg >=", value, "subsellflg");
            return (Criteria) this;
        }

        public Criteria andSubsellflgLessThan(String value) {
            addCriterion("SubSellFlg <", value, "subsellflg");
            return (Criteria) this;
        }

        public Criteria andSubsellflgLessThanOrEqualTo(String value) {
            addCriterion("SubSellFlg <=", value, "subsellflg");
            return (Criteria) this;
        }

        public Criteria andSubsellflgLike(String value) {
            addCriterion("SubSellFlg like", value, "subsellflg");
            return (Criteria) this;
        }

        public Criteria andSubsellflgNotLike(String value) {
            addCriterion("SubSellFlg not like", value, "subsellflg");
            return (Criteria) this;
        }

        public Criteria andSubsellflgIn(List<String> values) {
            addCriterion("SubSellFlg in", values, "subsellflg");
            return (Criteria) this;
        }

        public Criteria andSubsellflgNotIn(List<String> values) {
            addCriterion("SubSellFlg not in", values, "subsellflg");
            return (Criteria) this;
        }

        public Criteria andSubsellflgBetween(String value1, String value2) {
            addCriterion("SubSellFlg between", value1, value2, "subsellflg");
            return (Criteria) this;
        }

        public Criteria andSubsellflgNotBetween(String value1, String value2) {
            addCriterion("SubSellFlg not between", value1, value2, "subsellflg");
            return (Criteria) this;
        }
    }

    /**
     */
    public static class Criteria extends GeneratedCriteria {

        protected Criteria() {
            super();
        }
    }

    public static class Criterion {
        private String condition;

        private Object value;

        private Object secondValue;

        private boolean noValue;

        private boolean singleValue;

        private boolean betweenValue;

        private boolean listValue;

        private String typeHandler;

        public String getCondition() {
            return condition;
        }

        public Object getValue() {
            return value;
        }

        public Object getSecondValue() {
            return secondValue;
        }

        public boolean isNoValue() {
            return noValue;
        }

        public boolean isSingleValue() {
            return singleValue;
        }

        public boolean isBetweenValue() {
            return betweenValue;
        }

        public boolean isListValue() {
            return listValue;
        }

        public String getTypeHandler() {
            return typeHandler;
        }

        protected Criterion(String condition) {
            super();
            this.condition = condition;
            this.typeHandler = null;
            this.noValue = true;
        }

        protected Criterion(String condition, Object value, String typeHandler) {
            super();
            this.condition = condition;
            this.value = value;
            this.typeHandler = typeHandler;
            if (value instanceof List<?>) {
                this.listValue = true;
            } else {
                this.singleValue = true;
            }
        }

        protected Criterion(String condition, Object value) {
            this(condition, value, null);
        }

        protected Criterion(String condition, Object value, Object secondValue, String typeHandler) {
            super();
            this.condition = condition;
            this.value = value;
            this.secondValue = secondValue;
            this.typeHandler = typeHandler;
            this.betweenValue = true;
        }

        protected Criterion(String condition, Object value, Object secondValue) {
            this(condition, value, secondValue, null);
        }
    }
}